SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Ludovic FERRE
-- Create date: 2009-09-05
-- Description:	Retrieve Sections per AD
-- =============================================
CREATE PROCEDURE getSectionByAD
	@AD nvarchar(50)
AS
BEGIN
	SET NOCOUNT ON;
	SELECT SECTION_NAME
      FROM SECTION
     WHERE AD_ID = @AD
END
/* exec getSectionByAD '67' */
GO